23 research outputs found

    Problems in Designing Huge Datawarehouses and Datamarts

    Get PDF

    Reliability of diagnostic coding in intensive care patients

    Get PDF
    International audienceABSTRACT: INTRODUCTION: Administrative coding of medical diagnoses in intensive care unit (ICU) patients is mandatory in order to create databases for use in epidemiological and economic studies. We assessed the reliability of coding between different ICU physicians. METHOD: One hundred medical records selected randomly from 29,393 cases collected between 1998 and 2004 in the French multicenter Outcomerea ICU database were studied. Each record was sent to two senior physicians from independent ICUs who recoded the diagnoses using the International Statistical Classification of Diseases and Related Health Problems: Tenth Revision (ICD-10) after being trained according to guidelines developed by two French national intensive care medicine societies: the French Society of Intensive Care Medicine (SRLF) and the French Society of Anesthesiology and Intensive Care Medicine (SFAR). These codes were then compared with the original codes, which had been selected by the physician treating the patient. A specific comparison was done for the diagnoses of septicemia and shock (codes derived from A41 and R57, respectively). RESULTS: The ICU physicians coded an average of 4.6 +/- 3.0 (range 1 to 32) diagnoses per patient, with little agreement between the three coders. The primary diagnosis was matched by both external coders in 34% (95% confidence interval (CI) 25% to 43%) of cases, by only one in 35% (95% CI 26% to 44%) of cases, and by neither in 31% (95% CI 22% to 40%) of cases. Only 18% (95% CI 16% to 20%) of all codes were selected by all three coders. Similar results were obtained for the diagnoses of septicemia and/or shock. CONCLUSION: In a multicenter database designed primarily for epidemiological and cohort studies in ICU patients, the coding of medical diagnoses varied between different observers. This could limit the interpretation and validity of research and epidemiological programs using diagnoses as inclusion criteria

    Health Service Datawarehouse

    No full text
    This paper reports on a Data Warehouse application. The French national health department has to face numerous problems: financial, medical, social, accounts, public health and political. Thus, an efficient tool is needed for managing the decision support information system. In this context we have proposed the ERASME / SNIIR-AM Data Warehouse project. As far as our knowledge, it has been considered as the biggest Data Warehouse in the world.

    The ERASME project

    No full text

    Datawarehouse Design Methodology

    No full text

    Entrepôt de données pour l'Assurance Maladie

    No full text
    XXXV e journees de la SFDS (Societe de Statistique Francophone)Cet article relate une application des entrepôts de données. Le secteur de la santé pose de nombreuses problématiques : financières, médicales, sociales, comptables, de santé publique, et politique. Pour y répondre, il fallait créer un outil permettant de piloter le système de santé. Les données de base sont très volumineuses, mal consolidées, et peu propices à des analyses fines au niveau national. Dans ce contexte, l'Assurance Maladie met en œuvre un entrepôt de données à vocation décisionnelle : le projet ERASME / SNIIR-AM (régime général / inter régimes). A notre connaissance, il représente le plus gros datawarehouse du monde

    Problems in Designing Huge Datawarehouse and Datamarts

    No full text
    This paper reports on a Datawarehouse application. The French national health department has to face numerous problems: financial, medical, social, accounting, public health and political. Thus, an efficient tool is needed for managing the decision support information system. In this context we have proposed the ERASME / SNIIR-AM Datawarehouse project. To the best of our knowledge, it has been considered as the largest Datawarehouse in the world. The main challenge we had to solve were due to huge volumes. We have chosen to solve it by an ad hoc methodology mainly based on datamart desig

    Interface 2002

    No full text
    Présentation invité : "Histoire de l’informatique", Didier Nakache, Interface 2002 (Systèmes d’information pour l’aide à la décision), le 21 novembre 2002, organisé par le département STID (Lille II), Roubaix, FranceNational audienc

    Histoire de linformatique

    No full text
    National audienc

    Extraction automatique des diagnostics à partir des comptes rendus médicaux textuels

    No full text
    PARIS-CNAM (751032301) / SudocSudocFranceF
    corecore